﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of Article">
	<!-- This is a very specific dar intended for populating the yellow page catalogies of bizmall -->
	<Sql>
		SELECT
		Articles.id, baseTitle, translatedTitles, translationDetails, keyName
		FROM
		Articles
		LEFT OUTER JOIN ObjectTreeNodes t ON t.objectId = Articles.id
		LEFT OUTER JOIN ObjectTreeCounts as c on c.objectId = t.objectId
		WHERE
		t.rootId = '4468a155-66f4-4024-96ab-7914f9f12553' and
		t.depth = 1
		ORDER BY
		t.keyName
	</Sql>
</AdoNetDataAccess>
